﻿CREATE PROCEDURE [dbo].[sp_SelectAddressesForGeocoding]

AS
	SELECT TOP 10
       [prop_id]
      ,[geo_id]
      ,[file_as_name]
      ,[addr_line1]
      ,[addr_line2]
      ,[addr_line3]
      ,[addr_city]
      ,[addr_state]
      ,[addr_zip]
      ,[latitude]
      ,[longitude]
  FROM 
	[AMI].[dbo].[AD_Public]
  WHERE 
	[longitude] = 0.00 and [longitude] = 0.00
RETURN 0